﻿CREATE TABLE [entity].[ContactType] (
    [ContactTypeID] INT           IDENTITY (1, 1) NOT NULL,
    [Value]         VARCHAR (50)  NULL,
    [Description]   VARCHAR (500) NULL,
    [CreatedBy]     VARCHAR (50)  NULL,
    [CreatedDate]   DATETIME      NULL,
    [UpdatedBy]     VARCHAR (50)  NULL,
    [UpdatedDate]   DATETIME      NULL,
    [EndDate]       DATETIME      NULL,
    CONSTRAINT [PK_ContactType] PRIMARY KEY CLUSTERED ([ContactTypeID] ASC)
);

